All SQL Server Tables in a Schema

107

All SQL Server Tables in a Schema - 

DECLARE @schema SYSNAME;
SET @schema = N'some_schema';

SELECT [table] = s.name + N'.' + t.name
  FROM sys.tables AS t
  INNER JOIN sys.schemas AS s
  ON t.[schema_id] = s.[schema_id]
  WHERE s.name = @schema;

Comments

Submit
0 Comments

More Questions

url()- full() laravelhow to print in c# c# how to sort a list
print in c#get mouse position unity c# initialize array
string to int c#Retrieve url path Generate Random String
string to date vbmodal bootstrap style abril modal boostrap
c# serialize jsonboostrap 4 modal small modal popup bootstrap
model in bootsrap 4bootstrap modal popup c# random string
c sharp split stringstring to json c# laravel get current url
how get url in laravelhow to generate random letters in C# string to date
laravel route redirectcheck if two date ranges overlap c# Console.WriteLine($Hello Ana.ToUpper($)!);
phone number regex in c#list min and Max value in c# check shell command success
attribute c# get method name reflectionc# how to get screen resolution in class how to make dissapear an object in unity
wpf label text in centerhahhaa i hack u difference between all logging framework .NET Core
new color unityc# count files in directory and subdirectories Hello World Dotnet
import tachyons in reactHow can I cast string to enum .net core add header to soap request
open html file in browser using c++git find commits by message c# generate random date
how to get angular on visual studio macdotnet core encryption and decryption asp.net list all files in folder
C
CSS
Objective-C
PHP
Java
C++
Javascript
Html
Python
SQL
Swift
Ruby
Go
R
TypeScript
Kotlin
Assembly
VBA
Scala
Rust
Elixir
Dart
Haskell
Perl
Fortran
Matlab
Scheme
Julia
Lua
Delphi
Pascal
Solidity
BASIC
ActionScript
Csharp